package flex.lms.service;

import java.sql.Date;
import java.util.List;

import javax.annotation.Resource;

import org.common.db.query.HQLQuery;
import org.grizzly.service.BaseService;
import org.springframework.stereotype.Service;

import com.sun.org.apache.bcel.internal.generic.NEW;

import flex.lms.entity.ExperInfo;
import flex.lms.entity.StuExperGrade;
import flex.lms.entity.User;

@Service
public class ChaKanChengJiService {
	
	@Resource
	private BaseService baseService;
	

	
	public List<StuExperGrade> getChengJiByBianHao(StuExperGrade stuExperGrade){
		String hql = "from StuExperGrade g where g.userName = '"+stuExperGrade.getUserName()+"'";
		List<StuExperGrade> stuExperGradeList = baseService.findObjects(new HQLQuery(hql));
		return stuExperGradeList;
	}
	
	public List<ExperInfo> getExperInfoList(){
		String hql = "from ExperInfo where experFlag = 0";
		List<ExperInfo> experInfoList =  baseService.findObjects(new HQLQuery(hql));
		return experInfoList;
	}


}
